clear
set more off, perm
cd /Users/zachbrown/Projects/PriceTransparency/Data/


//////////////////////////////////////////////////////////
// Import CPI Health Care Services index from BLS
//////////////////////////////////////////////////////////

import excel using "price_index/cpi_medical_care_services.xls", firstrow cellrang(A11:P22) clear
rename Year year
keep year Annual
rename Annual price_index
drop if year>2014

// Set base year (1/1/2010)
replace price_index = price_index / 411.208

order year price_index
save price_index/cpi_hcs_index.dta, replace


